package com.hos.db.create.msg;

/**
 * 系统消息
 * Created by guom on 2018/10/15.
 */
public class MsgTable {
    public static String tableName = "msgs";
    public static String tableMsgId = "msg_id";//消息id
    public static String tableMsgTitle = "msg_title";// 消息标题
    public static String tableMsgType = "msg_type";// 消息类型
    public static String tableMsgContent = "msg_content";// 消息内容
    public static String tableMsgOwner = "msg_owner";// 消息所有者
    public static String tableMsgOwnerId = "msg_owner_id";// 消息所有者id
    public static String tableOwnerType = "msg_owner_type";// 消息所有者类型

    public static String tableMsgCreateTime = "msg_create_time";// 消息创建时间
    public static String tableMsgRead = "msg_read";// 消息是否阅读
    //
    public static String careteTable = "create table  "
            + tableName + " ( "
            + tableMsgId + "  varchar(200) primary key, "//主键
            + tableMsgTitle + " varchar(200), "
            + tableMsgType + " varchar(200), "
            + tableMsgContent + " longText,"
            + tableMsgOwner + " varchar(100), "
            + tableMsgOwnerId + " varchar(100), "
            + tableOwnerType + " varchar(100), "
            + tableMsgCreateTime + " datetime, "
            + tableMsgRead + " boolean"
            + "); ";

}
